Module Architecture

flowchart TD
    SUBSMOD["sadeem_subscription\nSubscription Base"]
    CF["sadeem_cloudflare\nCloudflare"]

    GRP["sadeem.dbfilter.server.group\ngroup of DBFilter servers\nshared defaults"]
    GRPS["sadeem.dbfilter.server.group.servers\nserver-to-group mapping\nrelation table"]
    DBF["sadeem.dbfilter.server\nshared Odoo instance\nDB filter routing"]
    SUB["sadeem.subscription (inherit)\ndbfilter type · server ref\ndatabase name"]
    PROD["product.template (inherit)\nDBFilter server group\nfor plan assignment"]
    INV["account.move (inherit)\ntrigger subscription actions\non invoice payment"]

    SUBSMOD --> SUB
    CF --> SUB

    GRP --> GRPS
    GRPS --> DBF
    SUB --> DBF
    SUB --> GRP
    PROD --> GRP
    INV --> SUB

    DBF --> A1([action_test_connection\ntest slave connectivity])
    DBF --> A2([action_create_database\ncreate DB on shared Odoo server])
    DBF --> A3([get_best_server\nselect server by capacity])

    GRP --> A4([_apply_dbfilter_server_group_defaults\ncopy Nginx · Cloudflare · domain to subscription])

    SUB --> A5([action_confirm override\nauto-provision DB + Nginx + DNS])
    SUB --> A6([action_drop_db override\ndrop database on DBFilter server])
    SUB --> A7([action_cancel override\nclean up DB and DNS resources])
    SUB --> A8([action_stop override\ndisable Nginx proxy host])
    SUB --> A9([action_start override\nre-enable Nginx proxy host])

    EXT[/DBFilter Slave Agent\nremote Odoo slave instance/]
    A2 --> EXT
    A3 --> EXT

Module Description

DB Filter SAAS - Provides database-filter-based SAAS infrastructure. Enables automated creation and management of multi-tenant Odoo instances on dedicated DB Filter servers with support for load balancing via server groups and automatic subscription creation from invoices.

Dependencies

• sadeem_cloudflare
• sadeem_subscription
• product

Menus

SAAS Management
└─ Infrastructure
    └─ DbFilter SAAS
        ├─ DBfilter Servers
        ├─ DBfilter Server Groups
        ├─ Packages
        └─ Modules

Subscription Type

This module adds the dbfilter subscription type. When selected, subscriptions are deployed as databases on a shared Odoo instance using the DB Filter mechanism for routing.

Key Fields

DBFilter Server (sadeem.dbfilter.server)

DBFilter Server Group (sadeem.dbfilter.server.group)

Subscription — DBFilter additions (sadeem.subscription inherit)

Lifecycle & States

DBFilter Server States

Transitions: - draft → confirm: action_confirm - confirm → draft: action_reset_draft - Any → cancel: action_cancel

Subscription Provisioning (DBFilter)

• action_confirm override: If dbfilter_saas_server_group is set, calls _apply_dbfilter_server_group_defaults() to auto-assign the best server and copy all defaults (IP, ports, domain, Cloudflare, Nginx) from the server group.
• action_run_subscription override: Creates the database on the DBFilter server via HTTP call to the shared Odoo instance; then provisions DNS and Nginx as in the base module.

Key Actions

Warnings & Important Notes

• Server deletion blocked: Cannot delete a sadeem.dbfilter.server while it has active linked subscriptions — raises ValidationError.
• No servers in group: get_best_server raises ValidationError if the server group has no member servers.
• Server must be confirmed: The dbfilter_server field domain filter restricts selection to servers with state = 'confirm'.
• Auto-assignment from group: When dbfilter_saas_server_group is set, action_confirm automatically overwrites server, domain, Cloudflare, and Nginx settings from the group's best server — manual overrides will be replaced.
• Capacity tracking: The server's available_capacity is purely computed; it will become negative if more subscriptions are added than expected_capacity — no hard enforcement exists.